Jason Tarpinian
Jason Tarpinian
Reactions
-
Re: Formula Help: Find Value in 1st Row in Same Column, without using Absolute References
I don't think that's possible to do with all of the parameters you've set. Your #5 mentions no premium apps, but is there a reason you can't build these formulas on a second sheet? You could then ref…1 · -
Re: Can I start a sumif at a particular row, then have it extend to every row following?
No worries! For the RowID, use the system column: For the Row# formula: Then in my example, I use 10, instead of row 40. Then you could take it to the next step with a column formula summing all valu…1 · -
Re: Formula that returns a value equal to every other day
If you set a sheet up like this using the RowID column to number rows for you, you can use the following formula to calculate every other day ("Start Date" is used as an arbitrary starting …2 · -
Re: Returning Multiple Rows Matching the Same Value and Skipping Rows that Don't
I gave out plenty of candy, and had enough leftover for myself to enjoy 😊 If you have Datamesh, build a report filtered to "Won" and do a Copy+Add to the target sheet. If not, follow my fun…1 · -
Re: If Contains lookup to another sheet result is empty show value from other cell in row?
In English, your logic would just be that If (your original formula) = blank, then do another formula, otherwise, (your original formula). In Smartsheet, it'd look like below, just replace the «INSER…1 ·
